Tabela MsgChannel

Definicja tabeli MsgChannel

Name

MsgChannel

Code

MsgChannel

Comment

 


Lista kolumn tabeli MsgChannel

Name

Code

MsgChannelID

MsgChannelID

MsgChannelTypeID

MsgChannelTypeID

Type

Type

CodeName

CodeName

Url

Url

Login

Login

Password

Password

DBName

DBName

Active

Active

Description

Description

DefaultValue

DefaultValue

TwoWaySupported

TwoWaySupported


Kolumna MsgChannelID tabeli MsgChannel

Definicja kolumny MsgChannelID tabeli MsgChannel

Name

MsgChannelID

Code

MsgChannelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MsgChannelTypeID tabeli MsgChannel

Definicja kolumny MsgChannelTypeID tabeli MsgChannel

Name

MsgChannelTypeID

Code

MsgChannelTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Type tabeli MsgChannel

Definicja kolumny Type tabeli MsgChannel

Name

Type

Code

Type

Data Type

NUMBER(10)

Mandatory

No

Comment

Typ zamówienia


Kolumna CodeName tabeli MsgChannel

Definicja kolumny CodeName tabeli MsgChannel

Name

CodeName

Code

CodeName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Url tabeli MsgChannel

Definicja kolumny Url tabeli MsgChannel

Name

Url

Code

Url

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Login tabeli MsgChannel

Definicja kolumny Login tabeli MsgChannel

Name

Login

Code

Login

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Password tabeli MsgChannel

Definicja kolumny Password tabeli MsgChannel

Name

Password

Code

Password

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna DBName tabeli MsgChannel

Definicja kolumny DBName tabeli MsgChannel

Name

DBName

Code

DBName

Data Type

VARCHAR2(128)

Mandatory

No

Comment

 


Kolumna Active tabeli MsgChannel

Definicja kolumny Active tabeli MsgChannel

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Description tabeli MsgChannel

Definicja kolumny Description tabeli MsgChannel

Name

Description

Code

Description

Data Type

VARCHAR2(500)

Mandatory

No

Comment

 


Kolumna DefaultValue tabeli MsgChannel

Definicja kolumny DefaultValue tabeli MsgChannel

Name

DefaultValue

Code

DefaultValue

Data Type

NUMBER(1)

Mandatory

Yes

Comment

W przypadku kilku aktywnych bramek SMS lub EMAIL wartosc ta decyduje, która bramka danego typu jest bramka domyslna. Opcja ta pozwala m.in. uproscic tworzenie patchy dla nowych zdarzen.


Kolumna TwoWaySupported tabeli MsgChannel

Definicja kolumny TwoWaySupported tabeli MsgChannel

Name

TwoWaySupported

Code

TwoWaySupported

Data Type

NUMBER(1)

Mandatory

Yes

Comment

czy kanal obsluguje komunikacje dwustronna


Lista kluczy tabeli MsgChannel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli MsgChannel

Definicja klucza Identifier_1 tabeli MsgChannel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment